Created temptable using case statement, convert function and unpivot function (to convert columns into rows and their values also stored in rows).If you get 5961672 rows affected that means your query is working fine. Therefore, we can use this temptable to create Star Schema model. Download the file from attachment and execute it by following bellow GIF.
Created temptable using case statement, convert function and unpivot function (to convert columns into rows and their values also stored in rows).If you get 5961672 rows affected that means your query is working fine. Therefore, we can use this temptable to create Star Schema model. Download the file from attachment and execute it by following bellow GIF.